<?php
include ("../conn.php");

$tib = "";
if(isset($_POST['submit'])){
	$upsql="update ".$databasepre."corpinfo set "
			."CNAME='".mysql_real_escape_string($_POST['CNAME'])."',CONTACTPEROSN='".mysql_real_escape_string($_POST['CONTACTPEROSN'])."',STREETADDRESS='".mysql_real_escape_string($_POST['STREETADDRESS'])
			."', CITY='".mysql_real_escape_string($_POST['CITY'])."', PROVINCE='".mysql_real_escape_string($_POST['PROVINCE'])
			."', COUNTRY='".mysql_real_escape_string($_POST['COUNTRY'])."', ZIP='".mysql_real_escape_string($_POST['ZIP'])."',TEL = '".mysql_real_escape_string($_POST['TEL'])."',MOBILEPHONE = '".mysql_real_escape_string($_POST['MOBILEPHONE'])."',FAX='".mysql_real_escape_string($_POST['FAX'])."',"
			."EMAIL='".mysql_real_escape_string($_POST['EMAIL'])."',BUSINESSTYPE='".mysql_real_escape_string($_POST['BUSINESSTYPE'])."',PRODUCT='".mysql_real_escape_string($_POST['PRODUCT'])."',EMPLOYEES='".mysql_real_escape_string($_POST['EMPLOYEES'])."',MAINMARKET='".mysql_real_escape_string($_POST['MAINMARKET'])."', "
			."MAINCUSTOMER='".mysql_real_escape_string($_POST['MAINCUSTOMER'])."',EXPORTPERCENT='".mysql_real_escape_string($_POST['EXPORTPERCENT'])."' ,TRADESHOW='".mysql_real_escape_string($_POST['TRADESHOW'])."',FACTORYSIZE='".mysql_real_escape_string($_POST['FACTORYSIZE'])."',FACTORYLOCATION='".mysql_real_escape_string($_POST['FACTORYLOCATION'])."', "
			."QAQC='".mysql_real_escape_string($_POST['QAQC'])."',PRODUCTLINE='".mysql_real_escape_string($_POST['PRODUCTLINE'])."',RDNUM='".mysql_real_escape_string($_POST['RDNUM'])."',QCNUM='".mysql_real_escape_string($_POST['QCNUM'])."',CERTIFICATION='".mysql_real_escape_string($_POST['CERTIFICATION'])."', "
			."MANUFACTURING='".mysql_real_escape_string($_POST['MANUFACTURING'])."', "

			."CNAME2='".mysql_real_escape_string($_POST['CNAME2'])."',CONTACTPEROSN2='".mysql_real_escape_string($_POST['CONTACTPEROSN2'])."',STREETADDRESS2='".mysql_real_escape_string($_POST['STREETADDRESS2'])
			."', CITY2='".mysql_real_escape_string($_POST['CITY2'])."', PROVINCE2='".mysql_real_escape_string($_POST['PROVINCE2'])
			."', COUNTRY2='".mysql_real_escape_string($_POST['COUNTRY2'])."', ZIP2='".mysql_real_escape_string($_POST['ZIP2'])."',TEL2 = '".mysql_real_escape_string($_POST['TEL2'])."',MOBILEPHONE2 = '".mysql_real_escape_string($_POST['MOBILEPHONE2'])."',FAX2='".mysql_real_escape_string($_POST['FAX2'])."',"
			."EMAIL2='".mysql_real_escape_string($_POST['EMAIL2'])."',BUSINESSTYPE2='".mysql_real_escape_string($_POST['BUSINESSTYPE2'])."',PRODUCT2='".mysql_real_escape_string($_POST['PRODUCT2'])."',EMPLOYEES2='".mysql_real_escape_string($_POST['EMPLOYEES2'])."',MAINMARKET2='".mysql_real_escape_string($_POST['MAINMARKET2'])."', "
			."MAINCUSTOMER2='".mysql_real_escape_string($_POST['MAINCUSTOMER2'])."',EXPORTPERCENT2='".mysql_real_escape_string($_POST['EXPORTPERCENT2'])."' ,TRADESHOW2='".mysql_real_escape_string($_POST['TRADESHOW2'])."',FACTORYSIZE2='".mysql_real_escape_string($_POST['FACTORYSIZE2'])."',FACTORYLOCATION2='".mysql_real_escape_string($_POST['FACTORYLOCATION2'])."', "
			."QAQC2='".mysql_real_escape_string($_POST['QAQC2'])."',PRODUCTLINE2='".mysql_real_escape_string($_POST['PRODUCTLINE2'])."',RDNUM2='".mysql_real_escape_string($_POST['RDNUM2'])."',QCNUM2='".mysql_real_escape_string($_POST['QCNUM2'])."',CERTIFICATION2='".mysql_real_escape_string($_POST['CERTIFICATION2'])."', "
			."MANUFACTURING2='".mysql_real_escape_string($_POST['MANUFACTURING2'])."' "

			."WHERE CID=1";

	//echo $upsql;
	mysql_query($upsql);
	$tib = "<font color=red>已修改成功！</font>";
}
$sql="select * from ".$databasepre."corpinfo WHERE CID=1";
$query=mysql_query($sql);
$row=mysql_fetch_array($query);
?>
<html><head>
<meta http-equiv=Content-Type content=text/html;charset=utf-8>
<link href="images/skin.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
	background-color: #EEF2FB;
}
-->
</style>
</head>
<body>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td width="17" valign="top" background="images/mail_leftbg.gif"><img src="images/left-top-right.gif" width="17" height="29" /></td>
    <td valign="top" background="images/content-bg.gif">
		<table width="100%" height="31" border="0" cellpadding="0" cellspacing="0" class="left_topbg" id="table2">
		  <tr><td height="31"><div class="titlebt">常规管理</div></td></tr>
		</table>
	</td>
    <td width="16" valign="top" background="images/mail_rightbg.gif"><img src="images/nav-right-bg.gif" width="16" height="29" /></td>
  </tr>
  <tr>
    <td valign="middle" background="images/mail_leftbg.gif">&nbsp;</td>
    <td valign="top" bgcolor="#F7F8F9">
	<!-- 网页内容部分开始 -->


	<table width="100%" height="138" border="0" cellpadding="0" cellspacing="0">
      <tr><td height="13" valign="top">&nbsp;</td></tr>
	  <tr><td class="left_txt">当前位置：联系信息</td></tr>
	  <!-- 一根线 -->
	  <tr><td height="20"><table width="100%" height="1" border="0" cellpadding="0" cellspacing="0" bgcolor="#CCCCCC"><tr><td></td></tr></table></td></tr>
	  <!-- 说明信息 -->
	  <tr><td><table width="100%" height="55" border="0" cellpadding="0" cellspacing="0"><tr>
				<td width="10%" height="55" valign="middle"><img src="images/title.gif" width="54" height="55"></td>
				<td width="90%" valign="top"><span class="left_txt2">在这里，您可以根据您的网站要求，修改设置网站的联系信息！</span><br>
						  </td>
				</tr></table>
		</td>
	  </tr>
	  <tr><td>&nbsp;</td></tr>
	  <tr><td><table width="100%" height="31" border="0" cellpadding="0" cellspacing="0" class="nowtable">
				  <tr><td class="left_bt2">&nbsp;&nbsp;&nbsp;&nbsp;系统参数设置</td></tr>
				</table>
		</td>
      </tr>
	  <tr><td><table width="900px" border="0" cellspacing="0" cellpadding="0">
				<form method=POST action="">
					<tr bgcolor="#f2f2f2">
						<td align="right" width="250px" height="30"  >Company Name：</td>
						<td  width="250px"><input name="CNAME" type="text" size="30" value="<?php echo $row['CNAME']?>"/></td>

						<td align="right" width="150px" align="right"  >公司名称：</td>
						<td  width="250px"><input name="CNAME2" type="text" size="30" value="<?php echo $row['CNAME2']?>"/></td>


					</tr>
					<tr>
						<td height="30" colspan="4" bgcolor="#99CCFF" style="font-size=12px;font-weight:bold;"><b>&nbsp;联系信息[Contact Information]</b></td>

					</tr>
					<tr>
						<td align="right" >Contact Person：</td>
						<td><input type="text" name="CONTACTPEROSN" size="30" value="<?php echo $row['CONTACTPEROSN']?>"/></td>

						<td align="right" >联系人：</td>
						<td><input type="text" name="CONTACTPEROSN2" size="30" value="<?php echo $row['CONTACTPEROSN2']?>"/></td>
					</tr>
					<tr>
						<td align="right" >Street Address：</td>
						<td><input type="text" name="STREETADDRESS" size="30" value="<?php echo $row['STREETADDRESS']?>"/></td>

						<td align="right" >街道地址：</td>
						<td><input type="text" name="STREETADDRESS2" size="30" value="<?php echo $row['STREETADDRESS2']?>"/></td>
					</tr>
					<tr bgcolor="#f2f2f2">
						<td align="right" >City：</td>
						<td><input name="CITY" type="text" size="30" value="<?php echo $row['CITY']?>"/></td>
						<td align="right" >城市：</td>
						<td><input name="CITY2" type="text" size="30" value="<?php echo $row['CITY2']?>"/></td>
					</tr>
					<tr>
						<td align="right">Province/State：</td>
						<td><input type="text" name="PROVINCE" size="30" value="<?php echo $row['PROVINCE']?>"/></td>
						<td align="right">省份：</td>
						<td><input type="text" name="PROVINCE2" size="30" value="<?php echo $row['PROVINCE2']?>"/></td>
					</tr>
					<tr>
						<td align="right">Country/Region：</td>
						<td><input type="text" name="COUNTRY" size="30" value="<?php echo $row['COUNTRY']?>"/></td>
						<td align="right">国家：</td>
						<td><input type="text" name="COUNTRY2" size="30" value="<?php echo $row['COUNTRY2']?>"/></td>
					</tr>
					<tr>
						<td align="right">Zip：</td>
						<td><input type="text" name="ZIP" size="30" value="<?php echo $row['ZIP']?>"/></td>
						<td align="right">邮编：</td>
						<td><input type="text" name="ZIP2" size="30" value="<?php echo $row['ZIP2']?>"/></td>
					</tr>
					<tr>
						<td align="right">Telephone：</td>
						<td><input type="text" name="TEL" size="30" value="<?php echo $row['TEL']?>"/></td>
						<td align="right">电话：</td>
						<td><input type="text" name="TEL2" size="30" value="<?php echo $row['TEL2']?>"/></td>
					</tr>
					<tr>
						<td align="right">Mobile Phone：</td>
						<td><input type="text" name="MOBILEPHONE" size="30" value="<?php echo $row['MOBILEPHONE']?>"/></td>
						<td align="right">移动电话：</td>
						<td><input type="text" name="MOBILEPHONE2" size="30" value="<?php echo $row['MOBILEPHONE2']?>"/></td>
					</tr>
					<tr>
						<td align="right">Fax：</td>
						<td><input type="text" name="FAX" size="30" value="<?php echo $row['FAX']?>"/></td>
						<td align="right">传真：</td>
						<td><input type="text" name="FAX2" size="30" value="<?php echo $row['FAX2']?>"/></td>
					</tr>
					<tr>
						<td align="right">Email：</td>
						<td><input type="text" name="EMAIL" size="30" value="<?php echo $row['EMAIL']?>"/></td>
						<td align="right">邮箱：</td>
						<td><input type="text" name="EMAIL2" size="30" value="<?php echo $row['EMAIL2']?>"/></td>
					</tr>


					<tr>
						<td height="30" colspan="4" bgcolor="#99CCFF" style="font-size=12px;font-weight:bold;"><b>&nbsp;基本信息[Basic Information]</b></td>
					</tr>
					<tr>
						<td align="right">Business Type：</td>
						<td><input type="text" name="BUSINESSTYPE" size="30" value="<?php echo $row['BUSINESSTYPE']?>"/></td>
						<td align="right">贸易类型：</td>
						<td><input type="text" name="BUSINESSTYPE2" size="30" value="<?php echo $row['BUSINESSTYPE2']?>"/></td>
					</tr>
					<tr>
						<td align="right">Product/Service<br/>(We Sell)：</td>
						<td><textarea name="PRODUCT" cols=30 rows=4 wrap="off"><?php echo $row['PRODUCT']?></textarea></td>
						<td align="right">产品服务<br/>(We Sell)：</td>
						<td><textarea name="PRODUCT2" cols=30 rows=4 wrap="off"><?php echo $row['PRODUCT2']?></textarea></td>
					</tr>
					<tr>
						<td align="right">Number of Employees：</td>
						<td><input type="text" name="EMPLOYEES" size="30" value="<?php echo $row['EMPLOYEES']?>"/></td>
						<td align="right">员工人数：</td>
						<td><input type="text" name="EMPLOYEES2" size="30" value="<?php echo $row['EMPLOYEES2']?>"/></td>
					</tr>
					<tr>
						<td height="30" colspan="4" bgcolor="#99CCFF" style="font-size=12px;font-weight:bold;"><b>&nbsp;贸易市场信息[Trade & Market]</b></td>
					</tr>
					<tr>
						<td align="right">Main Markets：</td>
						<td><input type="text" name="MAINMARKET" size="30" value="<?php echo $row['MAINMARKET']?>"/></td>
						<td align="right">主要市场：</td>
						<td><input type="text" name="MAINMARKET2" size="30" value="<?php echo $row['MAINMARKET2']?>"/></td>
					</tr>
					<tr>
						<td align="right">Main Customers：</td>
						<td><input type="text" name="MAINCUSTOMER" size="30" value="<?php echo $row['MAINCUSTOMER']?>"/></td>
						<td align="right">主要客户：</td>
						<td><input type="text" name="MAINCUSTOMER2" size="30" value="<?php echo $row['MAINCUSTOMER2']?>"/></td>
					</tr>
					<tr>
						<td align="right">Export Percentage：</td>
						<td><input type="text" name="EXPORTPERCENT" size="30" value="<?php echo $row['EXPORTPERCENT']?>"/></td>
						<td align="right">出口比例：</td>
						<td><input type="text" name="EXPORTPERCENT2" size="30" value="<?php echo $row['EXPORTPERCENT2']?>"/></td>
					</tr>
					<tr>
						<td align="right">Trade Shows：</td>
						<td><textarea name="TRADESHOW" cols=30 rows=4 wrap="off"><?php echo $row['TRADESHOW']?></textarea></td>
						<td align="right">展会信息：</td>
						<td><textarea name="TRADESHOW2" cols=30 rows=4 wrap="off"><?php echo $row['TRADESHOW2']?></textarea></td>
					</tr>

					<tr>
						<td height="30" colspan="4" bgcolor="#99CCFF" style="font-size=12px;font-weight:bold;"><b>&nbsp;工厂信息[Factory Information]</b></td>
					</tr>
					<tr>
						<td align="right">Factory Size (Sq.meters)：</td>
						<td><input type="text" name="FACTORYSIZE" size="30" value="<?php echo $row['FACTORYSIZE']?>"/></td>
						<td align="right">工厂面积：</td>
						<td><input type="text" name="FACTORYSIZE2" size="30" value="<?php echo $row['FACTORYSIZE2']?>"/></td>
					</tr>
					<tr>
						<td align="right">Factory Location：</td>
						<td><input type="text" name="FACTORYLOCATION" size="30" value="<?php echo $row['FACTORYLOCATION']?>"/></td>
						<td align="right">工厂地址：</td>
						<td><input type="text" name="FACTORYLOCATION2" size="30" value="<?php echo $row['FACTORYLOCATION2']?>"/></td>
					</tr>
					<tr>
						<td align="right">QA/QC：</td>
						<td><input type="text" name="QAQC" size="30" value="<?php echo $row['QAQC']?>"/></td>
						<td align="right">质检：</td>
						<td><input type="text" name="QAQC2" size="30" value="<?php echo $row['QAQC2']?>"/></td>
					</tr>
					<tr>
						<td align="right">Number of Production Lines：</td>
						<td><input type="text" name="PRODUCTLINE" size="30" value="<?php echo $row['PRODUCTLINE']?>"/></td>
						<td align="right">生产线人员：</td>
						<td><input type="text" name="PRODUCTLINE2" size="30" value="<?php echo $row['PRODUCTLINE2']?>"/></td>
					</tr>
					<tr>
						<td align="right">Number of R&D Staff：</td>
						<td><input type="text" name="RDNUM" size="30" value="<?php echo $row['RDNUM']?>"/></td>
						<td align="right">员工数：</td>
						<td><input type="text" name="RDNUM2" size="30" value="<?php echo $row['RDNUM2']?>"/></td>
					</tr>
					<tr>
						<td align="right">Number of QC Staff：</td>
						<td><input type="text" name="QCNUM" size="30" value="<?php echo $row['QCNUM']?>"/></td>
						<td align="right">Number of QC Staff：</td>
						<td><input type="text" name="QCNUM2" size="30" value="<?php echo $row['QCNUM2']?>"/></td>
					</tr>
					<tr>
						<td align="right">Management Certification：</td>
						<td><input type="text" name="CERTIFICATION" size="30" value="<?php echo $row['CERTIFICATION']?>"/></td>
						<td align="right">管理信用：</td>
						<td><input type="text" name="CERTIFICATION2" size="30" value="<?php echo $row['CERTIFICATION2']?>"/></td>
					</tr>
					<tr>
						<td align="right">Contract Manufacturing：</td>
						<td><input type="text" name="MANUFACTURING" size="30" value="<?php echo $row['MANUFACTURING']?>"/></td>
						<td align="right">联系制造：</td>
						<td><input type="text" name="MANUFACTURING2" size="30" value="<?php echo $row['MANUFACTURING2']?>"/></td>
					</tr>


					<tr height=50>
						<td>&nbsp;</td>
						<td colspan=3><input type="submit" value=" 确 定 " name=submit />   <input type="reset" value=" 设 置 " /> <?php echo $tib ?></td>
					</tr>



				</form>
			  </table>
			</td>
		</tr>



	 </table>






	<!-- 网页内容部分结束 -->
	</td>
    <td background="images/mail_rightbg.gif">&nbsp;</td>
  </tr>
  <tr>
    <td valign="bottom" background="images/mail_leftbg.gif"><img src="images/buttom_left2.gif" width="17" height="17" /></td>
    <td background="images/buttom_bgs.gif"><img src="images/buttom_bgs.gif" width="17" height="17"></td>
    <td valign="bottom" background="images/mail_rightbg.gif"><img src="images/buttom_right2.gif" width="16" height="17" /></td>
  </tr>
</table>
</body>
</html>
